<?php

$enable_profiling = 1;

require_once("sys.inc");

$top = "common";
$content = "tournaments";
$side = "tournaments";

$q = "SELECT * FROM $table_tournament
LEFT JOIN $table_country ON $table_country.country_id=$table_tournament.country_id
LEFT JOIN $table_city ON $table_city.city_id=$table_tournament.city_id
WHERE 1
ORDER BY end_date DESC";

$tlist = Array();

$result = mysql_query($q);
while ($row = mysql_fetch_object($result))
{
	array_push($tlist, $row);
}
require 'tpl/index.tpl';

?>